Microsoft Excel 2019 for beginners and intermediates by Jan Zitniak

Author:Jan Zitniak [Zitniak, Jan]
Language: eng
Format: azw3
Publisher: IT Education
Published: 2018-12-02T16:00:00+00:00

Example 2

Download this exercise from www.janzitniakbooks.com.

VLOOKUP can also be used if Lookup_value does not contain the exact value sought. Consider the following table:

Here you want to know the tax rate for specified income, where the income can be any value. In this example, you are searching for both the exact and closest values. The closest value is equal to or less than the lookup value. The procedure is similar to the previous case except that no Range_lookup argument is filled in (or you can specify TRUE or 1). Therefore, you would enter the following formula in Cell B2:

=VLOOKUP(A2,D:E,2)

Note: If Range_lookup has the value of TRUE or no value is entered, then the values in the first column of Table_array have to be placed in ascending order, or else VLOOKUP will not necessarily return the correct value.

Illustration

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.